/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : localhost
 Source Database       : framework

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : utf-8

 Date: 04/02/2018 17:14:03 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ht_sys_account`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_account`;
CREATE TABLE `ht_sys_account` (
  `uuid` char(32) NOT NULL COMMENT '主键',
  `account` varchar(128) DEFAULT NULL COMMENT '名称',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `phone` varchar(30) DEFAULT NULL COMMENT '电话号码',
  `email` varchar(128) DEFAULT NULL COMMENT '邮箱地址',
  `password` char(32) DEFAULT NULL COMMENT '标识',
  `salt` varchar(32) DEFAULT NULL COMMENT '盐',
  `rank` varchar(32) DEFAULT NULL COMMENT '级别',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `orgnazation` varchar(50) DEFAULT NULL COMMENT '组织机构',
  `creator` char(32) DEFAULT NULL COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `mender` char(32) DEFAULT NULL COMMENT '最后修改者',
  `modifyTime` datetime DEFAULT NULL COMMENT '最后修改时间',
  `deletedBy` char(32) DEFAULT NULL COMMENT '删除者',
  `deletedMarker` tinyint(4) DEFAULT NULL COMMENT '删除标志',
  `deleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='账号';

-- ----------------------------
--  Records of `ht_sys_account`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_account` VALUES ('062875a3427543cd81939039ffa8e883', 'jzg', '贾治国', '18635159830', 'jzgw2154@qq.com', '6c5dccce97bfeed9c1ffbfcc47bb7fb0', '36cc6786e7aa1323797bb4b21b686f73', 'super', null, '000001#001#', null, null, null, null, null, null, null), ('834ec02550d546cc86ecb720540bf2d9', 'jixu', '吉旭', null, null, 'e8d1cc73d495a8d788c6ced4f56c1944', 'aml4dQ==', 'super', null, '000001#001#', null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `ht_sys_attachment`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_attachment`;
CREATE TABLE `ht_sys_attachment` (
  `uuid` char(32) NOT NULL COMMENT '主键',
  `filename` varchar(50) DEFAULT NULL COMMENT '文件名',
  `filePath` varchar(1000) DEFAULT NULL COMMENT '文件存储路径',
  `suffix` varchar(50) DEFAULT NULL COMMENT '文件后缀',
  `mineType` varchar(50) DEFAULT NULL COMMENT '文件MINETYPE',
  `fileSize` bigint(20) DEFAULT NULL COMMENT '文件大小',
  `uploadTime` datetime DEFAULT NULL COMMENT '上传时间',
  `uploader` char(32) DEFAULT NULL COMMENT '上传者',
  `deleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  `deleteBy` char(32) DEFAULT NULL COMMENT '删除者',
  `entityName` varchar(255) DEFAULT NULL COMMENT '类型名称',
  `fieldName` varchar(50) DEFAULT NULL COMMENT '类型对应字段名称',
  `pkValue` char(32) DEFAULT NULL COMMENT '类型对应主键',
  `status` smallint(6) DEFAULT NULL COMMENT '文件状态',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统附件';

-- ----------------------------
--  Table structure for `ht_sys_dataset`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_dataset`;
CREATE TABLE `ht_sys_dataset` (
  `uuid` char(32) NOT NULL COMMENT '主键',
  `label` varchar(128) DEFAULT NULL COMMENT '显示名称',
  `code` varchar(32) DEFAULT NULL COMMENT '编码',
  `statement` varchar(1000) DEFAULT NULL COMMENT '查询名称',
  `serial` int(11) DEFAULT NULL COMMENT '索引',
  `creator` char(32) DEFAULT NULL COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `mender` char(32) DEFAULT NULL COMMENT '最后修改者',
  `modifyTime` datetime DEFAULT NULL COMMENT '最后修改时间',
  `deletedBy` char(32) DEFAULT NULL COMMENT '删除者',
  `deletedMarker` tinyint(4) DEFAULT NULL COMMENT '删除标志',
  `deleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据集合';

-- ----------------------------
--  Records of `ht_sys_dataset`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_dataset` VALUES ('05f2f40c07df4c4db3cd24f1bf8a4f84', '角色列表', 'RoleList', 'select uuid as code ,name as label from ht_sys_role order by dataLevel DESC', '1', null, null, null, null, null, null, null), ('5ed7c378e2524bc5b3cc8cb92067c438', '用户列表', 'UserList', 'select uuid as code, concat(name,\'(\',account,\')\') as label from ht_sys_account order by account', '3', null, null, null, null, null, null, null), ('5f28e57d023146aaaf20c3b515b0ca07', '部门列表', 'OrgList', 'select route as code, name as label from ht_sys_orgnazation order by route', '2', null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `ht_sys_dictionary`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_dictionary`;
CREATE TABLE `ht_sys_dictionary` (
  `uuid` char(32) NOT NULL COMMENT '主键',
  `label` varchar(128) DEFAULT NULL COMMENT '显示名称',
  `code` varchar(32) DEFAULT NULL COMMENT '编码',
  `parent` char(32) DEFAULT NULL COMMENT '所属分类编码',
  `serial` int(11) DEFAULT NULL COMMENT '索引',
  `creator` char(32) DEFAULT NULL COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `mender` char(32) DEFAULT NULL COMMENT '最后修改者',
  `modifyTime` datetime DEFAULT NULL COMMENT '最后修改时间',
  `deletedBy` char(32) DEFAULT NULL COMMENT '删除者',
  `deletedMarker` tinyint(4) DEFAULT NULL COMMENT '删除标志',
  `deleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典';

-- ----------------------------
--  Records of `ht_sys_dictionary`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_dictionary` VALUES ('11c6f3397b744a95af2b1da4e3e23c6f', '管理角色', 'manage', 'da877d95a50445dbae4b4c14ae44c507', '2', null, null, null, null, null, null, null), ('1b7389ca9e974f1ab8345beb0a306fa4', '超级管理员', 'super', '266e51eb04c241a58cf999d73e9daedc', '1', null, null, null, null, null, null, null), ('266e51eb04c241a58cf999d73e9daedc', '用户级别', 'UserRank', null, '3', null, null, null, null, null, null, null), ('26b15b5777a24953a6db9da4eb3bf1f2', '部门及子部门数据', '3', '6d0b5da20e904b89aea01c12be7f9f6f', '3', null, null, null, null, null, null, null), ('2c867e13f3434f05bfa6e9a3d5008565', '个人数据', '1', '6d0b5da20e904b89aea01c12be7f9f6f', '1', null, null, null, null, null, null, null), ('343fac55937449afba366a0dfe8164ef', '菜单项', 'item', 'dc0af9e9fde7466688f10eccd9e6e408', '2', null, null, null, null, null, null, null), ('39ecd184e02a48deba56da63c7e2b7b1', '操作权限', 'action', 'a1fff0daa88b409f97876ce6cfc3e303', '3', null, null, null, null, null, null, null), ('3ac4f4c69c3749758a2b2ec56b65b1c8', '菜单组', 'group', 'dc0af9e9fde7466688f10eccd9e6e408', '1', null, null, null, null, null, null, null), ('4026843759b7483dbc52018a2f4dcb40', '部门', 'depart', '900007e5637045ffaae9c85ce3e614df', '1', null, null, null, null, null, null, null), ('44702f9514e34fa5a36616f9a3a05656', '普通用户', 'normal', '266e51eb04c241a58cf999d73e9daedc', '2', null, null, null, null, null, null, null), ('62c070f3a5c94e54adbfaa0fde5a3eec', '单位及子单位数据', '5', '6d0b5da20e904b89aea01c12be7f9f6f', '5', null, null, null, null, null, null, null), ('6a1afe15f2f24c9991b64ac5ee2b2e6a', '页面权限', 'page', 'a1fff0daa88b409f97876ce6cfc3e303', '2', null, null, null, null, null, null, null), ('6d0b5da20e904b89aea01c12be7f9f6f', '数据访问权限', 'DataLevel', null, '1', null, null, null, null, null, null, null), ('73b5e720f6c2485597a34fa8943ff9ff', '单位数据', '4', '6d0b5da20e904b89aea01c12be7f9f6f', '4', null, null, null, null, null, null, null), ('8c518f2c82054a27a3d7068a796c9f78', '全部数据', '9', '6d0b5da20e904b89aea01c12be7f9f6f', '6', null, null, null, null, null, null, null), ('900007e5637045ffaae9c85ce3e614df', '组织机构级别', 'OrgnazationRank', null, '2', null, null, null, null, null, null, null), ('9c1815a8882b40599645017995f5c2a2', '权限组', 'group', 'a1fff0daa88b409f97876ce6cfc3e303', '1', null, null, null, null, null, null, null), ('a1fff0daa88b409f97876ce6cfc3e303', '权限类型', 'PermissionType', null, '6', null, null, null, null, null, null, null), ('b06c054dce524ba3b829f59c82729870', '部门数据', '2', '6d0b5da20e904b89aea01c12be7f9f6f', '2', null, null, null, null, null, null, null), ('c41e90a91b074532afe2b8adf6d1af9b', '普通角色', 'normal', 'da877d95a50445dbae4b4c14ae44c507', '1', null, null, null, null, null, null, null), ('da877d95a50445dbae4b4c14ae44c507', '角色级别', 'RoleRank', null, '5', null, null, null, null, null, null, null), ('dc0af9e9fde7466688f10eccd9e6e408', '菜单类型', 'MenuType', null, '4', null, null, null, null, null, null, null), ('f10cef7ac5bb49ae8aae292a8d379ae4', '单位', 'unit', '900007e5637045ffaae9c85ce3e614df', '2', null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `ht_sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_menu`;
CREATE TABLE `ht_sys_menu` (
  `uuid` char(32) NOT NULL COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `parentId` char(32) DEFAULT NULL COMMENT '上级菜单',
  `type` varchar(32) DEFAULT NULL COMMENT '类型',
  `level` tinyint(4) DEFAULT NULL COMMENT '级别',
  `enter` varchar(255) DEFAULT NULL COMMENT '访问地址',
  `permission` varchar(255) DEFAULT NULL COMMENT '对应权限',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `serial` int(11) DEFAULT NULL COMMENT '索引',
  `creator` char(32) DEFAULT NULL COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `mender` char(32) DEFAULT NULL COMMENT '最后修改者',
  `modifyTime` datetime DEFAULT NULL COMMENT '最后修改时间',
  `deletedBy` char(32) DEFAULT NULL COMMENT '删除者',
  `deletedMarker` tinyint(4) DEFAULT NULL COMMENT '删除标志',
  `deleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  `childrenCount` int(11) DEFAULT NULL COMMENT '子类型数量',
  `icon` varchar(32) DEFAULT NULL COMMENT '样式',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单';

-- ----------------------------
--  Records of `ht_sys_menu`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_menu` VALUES ('1', '企业菜单', '#', 'module', '1', null, null, null, '1', null, null, null, null, null, null, null, '2', null), ('1e385c4ac2da4705ad71db44746727d5', '主从表视图', 'c98cf7c39ca64a08957d875786152444', 'item', '3', '/view4', null, null, '4', null, null, null, null, null, null, null, '0', null), ('294042caeb8a40ecb19d6a6347670fb7', '上传列子', 'c98cf7c39ca64a08957d875786152444', 'item', '3', '/core/attachment/test', null, null, '5', null, null, null, null, null, null, null, '0', null), ('43403b9870fc4a6d8c6b12d7f8c46a60', '字典配置', '4981a1370d384f2f899ab141a855f30a', 'item', '3', '/core/dictionary', 'zdpz', null, '1', null, null, null, null, null, null, null, '0', null), ('4981a1370d384f2f899ab141a855f30a', '系统管理', '1', 'group', '2', null, null, null, '2', null, null, null, null, null, null, null, '8', 'fa fa fa-bar-chart-o'), ('6adfbe64488b4366820f648e2361442c', '组织机构管理', '4981a1370d384f2f899ab141a855f30a', 'item', '3', '/core/orgnazation', null, null, '3', null, null, null, null, null, null, null, '0', null), ('71ebb50c4da74b9eb148de206182e24a', '权限配置', '4981a1370d384f2f899ab141a855f30a', 'item', '3', '/core/permission', null, null, '6', null, null, null, null, null, null, null, '0', null), ('747bc4189bb64d1b8e309514b48c7401', '附件管理', '4981a1370d384f2f899ab141a855f30a', 'item', '3', '/core/attachment', null, null, '8', null, null, null, null, null, null, null, '0', null), ('8f99fccb452343a1a1d19e604fdc5add', '主副表视图', 'c98cf7c39ca64a08957d875786152444', 'item', '3', '/view3', null, null, '3', null, null, null, null, null, null, null, '0', null), ('8fae8ce6b26445eab450e6c347e90780', '角色配置', '4981a1370d384f2f899ab141a855f30a', 'item', '3', '/core/role', null, null, '5', null, null, null, null, null, null, null, '0', null), ('c13111e1c1c04c6f836f7f415a39d790', '用户管理', '4981a1370d384f2f899ab141a855f30a', 'item', '3', '/core/account', null, null, '4', null, null, null, null, null, null, null, '0', null), ('c96c3fdfcc4b46a7aa417aa8e172325a', '菜单配置', '4981a1370d384f2f899ab141a855f30a', 'item', '3', '/core/menu', null, null, '7', null, null, null, null, null, null, null, '0', null), ('c98cf7c39ca64a08957d875786152444', '主页', '1', 'group', '2', null, null, null, '1', null, null, null, null, null, null, null, '5', 'fa fa-home'), ('d7812ce334494eb5a6aa658b35b5af1a', '数据集配置', '4981a1370d384f2f899ab141a855f30a', 'item', '3', '/core/dataset', null, null, '2', null, null, null, null, null, null, null, '0', null), ('e329f67c56104ebe82376fd748a3398e', '单表视图', 'c98cf7c39ca64a08957d875786152444', 'item', '3', '/view1', null, null, '1', null, null, null, null, null, null, null, '0', null), ('fb7df4d4bd6341d0bd4ed9dc78c60624', '树表视图', 'c98cf7c39ca64a08957d875786152444', 'item', '3', '/view2', null, null, '2', null, null, null, null, null, null, null, '0', null);
COMMIT;

-- ----------------------------
--  Table structure for `ht_sys_orgnazation`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_orgnazation`;
CREATE TABLE `ht_sys_orgnazation` (
  `uuid` char(32) NOT NULL COMMENT '主键',
  `name` varchar(128) DEFAULT NULL COMMENT '名称',
  `fullName` varchar(1000) DEFAULT NULL COMMENT '全称',
  `rank` varchar(32) DEFAULT NULL COMMENT '级别',
  `sign` char(4) DEFAULT NULL COMMENT '标识',
  `route` varchar(1000) DEFAULT NULL COMMENT '全路径',
  `serial` int(11) DEFAULT NULL COMMENT '索引',
  `parentId` char(32) DEFAULT NULL COMMENT '父id',
  `creator` char(32) DEFAULT NULL COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `mender` char(32) DEFAULT NULL COMMENT '最后修改者',
  `modifyTime` datetime DEFAULT NULL COMMENT '最后修改时间',
  `deletedBy` char(32) DEFAULT NULL COMMENT '删除者',
  `deletedMarker` tinyint(4) DEFAULT NULL COMMENT '删除标志',
  `deleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  `childrenCount` int(11) DEFAULT NULL COMMENT '子类型数量',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='组织机构';

-- ----------------------------
--  Records of `ht_sys_orgnazation`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_orgnazation` VALUES ('4884188d98744e49abbb2801f6daaf7b', '软件研发部', null, 'depart', '01', '000001#001#', '1', '969643ab79ec4c258916daaf08590793', '0', '2018-02-07 16:14:53', '0', '2018-02-07 16:14:54', null, null, null, '1'), ('5605d7c9b0bd4b7798e2b2576e444ec4', '框架开发小组', null, 'depart', '0001', '000001#001001#', '1', '4884188d98744e49abbb2801f6daaf7b', '0', '2018-02-07 16:38:54', '0', '2018-02-07 16:38:54', null, null, null, '0'), ('781109a10f2547909f8c4af069781fa1', '中国环天伟业', '中国环天伟业科技有限公司', 'unit', 'htwy', '000#', '0', '#', null, null, null, null, null, null, null, '1'), ('969643ab79ec4c258916daaf08590793', '山西环天伟业', null, 'unit', '02', '000001#', '1', '781109a10f2547909f8c4af069781fa1', '0', '2018-02-06 10:33:41', '0', '2018-02-06 10:33:41', null, null, null, '1');
COMMIT;

-- ----------------------------
--  Table structure for `ht_sys_permission`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_permission`;
CREATE TABLE `ht_sys_permission` (
  `uuid` char(32) NOT NULL COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '权限名称',
  `code` varchar(32) DEFAULT NULL COMMENT '权限编码',
  `parentId` char(32) DEFAULT NULL COMMENT '上级权限',
  `type` varchar(32) DEFAULT NULL COMMENT '权限类型',
  `serial` int(11) DEFAULT NULL COMMENT '索引',
  `creator` char(32) DEFAULT NULL COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `mender` char(32) DEFAULT NULL COMMENT '最后修改者',
  `modifyTime` datetime DEFAULT NULL COMMENT '最后修改时间',
  `deletedBy` char(32) DEFAULT NULL COMMENT '删除者',
  `deletedMarker` tinyint(4) DEFAULT NULL COMMENT '删除标志',
  `deleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  `childrenCount` int(11) DEFAULT NULL COMMENT '子类型数量',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限';

-- ----------------------------
--  Records of `ht_sys_permission`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_permission` VALUES ('05e4855dc06b40078644f26934147841', '菜单配置', 'cdpz', '61b0131ba4534356997620b42fe1063b', 'page', '7', null, null, null, null, null, null, null, '0'), ('0d85cfa3b7204eab9a597d2f7ee7efbc', '权限配置', 'qxpz', '61b0131ba4534356997620b42fe1063b', 'page', '6', null, null, null, null, null, null, null, '0'), ('1', '企业权限', '', '#', 'module', '1', null, null, '', null, null, null, null, '1'), ('61b0131ba4534356997620b42fe1063b', '系统管理', 'xtgl', '1', 'group', '1', null, null, null, null, null, null, null, '7'), ('6e5fe102c73346b085d6518d4a220c3e', '角色配置', 'jspz', '61b0131ba4534356997620b42fe1063b', 'page', '5', null, null, null, null, null, null, null, '0'), ('7e9c3d3b25f84eafbfcc3d1eb6c31aba', '字典配置', 'zdpz', '61b0131ba4534356997620b42fe1063b', 'page', '1', null, null, null, null, null, null, null, '0'), ('b084a845213641f3a782e23951f20aee', '数据集配置', 'sjjpz', '61b0131ba4534356997620b42fe1063b', 'page', '2', null, null, null, null, null, null, null, '0'), ('e1e3ef4fbb5443389f19804b3cd1d0fb', '用户管理', 'yhgl', '61b0131ba4534356997620b42fe1063b', 'page', '4', null, null, null, null, null, null, null, '0'), ('fabecfe16ebb4002a111a102f2fbe403', '组织机构管理', 'zzjggl', '61b0131ba4534356997620b42fe1063b', 'page', '3', null, null, null, null, null, null, null, '0');
COMMIT;

-- ----------------------------
--  Table structure for `ht_sys_r_account_role`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_r_account_role`;
CREATE TABLE `ht_sys_r_account_role` (
  `uuid` char(32) NOT NULL,
  `accountId` char(32) DEFAULT NULL,
  `roleId` char(32) DEFAULT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `ht_sys_r_account_role`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_r_account_role` VALUES ('34b9cf015e384a029e2f4b2b4e3385e0', '3c628d3caa3841b48012fa6d61f21857', 'b33ca3e589924986bcb7bde7e4ec43b3');
COMMIT;

-- ----------------------------
--  Table structure for `ht_sys_r_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_r_role_permission`;
CREATE TABLE `ht_sys_r_role_permission` (
  `roleId` char(32) NOT NULL,
  `permissionId` char(32) NOT NULL,
  PRIMARY KEY (`roleId`,`permissionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `ht_sys_r_role_permission`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_r_role_permission` VALUES ('b33ca3e589924986bcb7bde7e4ec43b3', '0d85cfa3b7204eab9a597d2f7ee7efbc'), ('b33ca3e589924986bcb7bde7e4ec43b3', 'e1e3ef4fbb5443389f19804b3cd1d0fb'), ('c780507289ec441fb9e3018e34530018', '05e4855dc06b40078644f26934147841'), ('c780507289ec441fb9e3018e34530018', '0d85cfa3b7204eab9a597d2f7ee7efbc'), ('c780507289ec441fb9e3018e34530018', '1'), ('c780507289ec441fb9e3018e34530018', '61b0131ba4534356997620b42fe1063b'), ('c780507289ec441fb9e3018e34530018', '6e5fe102c73346b085d6518d4a220c3e'), ('c780507289ec441fb9e3018e34530018', '7e9c3d3b25f84eafbfcc3d1eb6c31aba'), ('c780507289ec441fb9e3018e34530018', 'b084a845213641f3a782e23951f20aee'), ('c780507289ec441fb9e3018e34530018', 'e1e3ef4fbb5443389f19804b3cd1d0fb'), ('c780507289ec441fb9e3018e34530018', 'fabecfe16ebb4002a111a102f2fbe403');
COMMIT;

-- ----------------------------
--  Table structure for `ht_sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `ht_sys_role`;
CREATE TABLE `ht_sys_role` (
  `uuid` char(32) NOT NULL COMMENT '主键',
  `name` varchar(128) DEFAULT NULL COMMENT '名称',
  `sign` char(4) DEFAULT NULL COMMENT '标识',
  `rank` varchar(32) DEFAULT NULL COMMENT '级别',
  `dataLevel` tinyint(4) DEFAULT NULL COMMENT '数据级别',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `serial` int(11) DEFAULT NULL COMMENT '索引',
  `orgnazation` char(32) DEFAULT NULL COMMENT '组织机构',
  `creator` char(32) DEFAULT NULL COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `mender` char(32) DEFAULT NULL COMMENT '最后修改者',
  `modifyTime` datetime DEFAULT NULL COMMENT '最后修改时间',
  `deletedBy` char(32) DEFAULT NULL COMMENT '删除者',
  `deletedMarker` tinyint(4) DEFAULT NULL COMMENT '删除标志',
  `deleteTime` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色';

-- ----------------------------
--  Records of `ht_sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `ht_sys_role` VALUES ('b33ca3e589924986bcb7bde7e4ec43b3', '普通角色', '1111', 'manage', '9', '0', null, null, null, null, null, null, null, null, null), ('c780507289ec441fb9e3018e34530018', '系统管理员', '2222', 'manage', '9', null, null, null, null, null, null, null, null, null, null);
COMMIT;

